package org.travel.api.travel.dao.Chao;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.travel.api.travel.pojo.Airport;

public interface AirportDao extends JpaRepository<Airport,Long>, JpaSpecificationExecutor<Airport> {

    @Query("select a from Airport a where a.cityId=:id")
    public Airport getByCityid(@Param("id") Integer id);

}
